A framework for detecting unnecessary industrial data in ETL processes

Extract transform and load (ETL) is a critical process used by industrial organisations to shift data from one database to another, such as from an operational system to a data warehouse. With the increasing amount of data stored by industrial organisations, some ETL processes can take in excess of 12 hours to complete; this can leave decision makers stranded while they wait for the data needed to support their decisions. After designing the ETL processes, inevitably data requirements can change, and much of the data that goes through the ETL process may not ever be used or needed. This paper therefore proposes a framework for dynamically detecting and predicting unnecessary data and preventing it from slowing down ETL processes - either by removing it entirely or deprioritizing it. Other advantages of the framework include being able to prioritise data cleansing tasks and determining what data should be processed first and placed into fast access memory. We show existing example algorithms that can be used for each component of the framework, and present some initial testing results as part of our research to determine whether the framework can help to reduce ETL time.This is the author accepted manuscript. The final version is available from IEEE via http://dx.doi.org/10.1109/INDIN.2014.694555

Parallel Unsmoothed Aggregation Algebraic Multigrid Algorithms on GPUs

We design and implement a parallel algebraic multigrid method for isotropic graph Laplacian problems on multicore Graphical Processing Units (GPUs). The proposed AMG method is based on the aggregation framework. The setup phase of the algorithm uses a parallel maximal independent set algorithm in forming aggregates and the resulting coarse level hierarchy is then used in a K-cycle iteration solve phase with a $\ell^1$-Jacobi smoother. Numerical tests of a parallel implementation of the method for graphics processors are presented to demonstrate its effectiveness.Comment: 18 pages, 3 figure

Reliability of two behavioral tools to assess pain in preterm neonates

CONTEXT: One of the main difficulties in adequately treating the pain of neonatal patients is the scarcity of validated pain evaluation methods for this population. OBJECTIVE: To analyze the reliability of two behavioral pain scales in neonates. TYPE OF STUDY: Cross-sectional. SETTING: University hospital neonatal intensive care unit. PARTICIPANTS: 22 preterm neonates were studied, with gestational age of 34 ± 2 weeks, birth weight of 1804 ± 584 g, 68% female, 30 ± 12 hours of life, and 30% intubated. PROCEDURES: Two neonatologists (A and B) observed the patients at the bedside and on video films for 10 minutes. The Neonatal Facial Coding System and the Clinical Scoring System were scored at 1, 5, and 10 minutes. The final score was the median of the three values for each observer and scale. A and B were blinded to each other. Video assessments were made three months after bedside evaluations. MAIN MEASUREMENTS: End scores were compared between the observers using the intraclass correlation coefficient and bias analysis (paired t test and signal test). RESULTS: For the Neonatal Facial Coding System, at the bedside and on video, A and B showed a significant correlation of scores (intraclass correlation score: 0.62), without bias between them (t test and signal test: p > 0.05). For the Clinical Scoring System bedside assessment, A and B showed correlation of scores (intraclass correlation score: 0.55), but bias was also detected between them: A scored on average two points higher than B (paired t test and signal test: p 0,05). Para a Escala de Conforto Clínico à beira do leito, os escores obtidos por A e B mostraram uma correlação significante (0,55), foi detectado: o escore obtido por A foi, em média, dois pontos superior ao de B (teste t e do sinal: p < 0,05). Para a mesma escala aplicada em vídeo, os escores obtidos por A e B não mostraram correlação (0,25) e detectou-se viés (teste t e do sinal: p < 0,05). CONCLUSÃO: Os resultados reforçam a confiabilidade do Sistema de Codificação da Atividade Facial Neonatal aplicado à beira do leito para a avaliação da dor no recém-nascido pré-termo.Universidade Federal de São Paulo (UNIFESP) Escola Paulista de MedicinaUniversidade Federal de São Paulo (UNIFESP) Escola Paulista de Medicina Neonatal DivisionUniversidade Federal de São Paulo (UNIFESP) Escola Paulista de Medicina Department of EpidemiologyUNIFESP, EPM, Neonatal DivisionUNIFESP, EPM, Department of EpidemiologySciEL

Pompe disease diagnosis and management guideline

ACMG standards and guidelines are designed primarily as an educational resource for physicians and other health care providers to help them provide quality medical genetic services. Adherence to these standards and guidelines does not necessarily ensure a successful medical outcome. These standards and guidelines should not be considered inclusive of all proper procedures and tests or exclusive of other procedures and tests that are reasonably directed to obtaining the same results. in determining the propriety of any specific procedure or test, the geneticist should apply his or her own professional judgment to the specific clinical circumstances presented by the individual patient or specimen. It may be prudent, however, to document in the patient's record the rationale for any significant deviation from these standards and guidelines.Duke Univ, Med Ctr, Durham, NC 27706 USAOregon Hlth Sci Univ, Portland, OR 97201 USANYU, Sch Med, New York, NY USAUniv Florida, Coll Med, Powell Gene Therapy Ctr, Gainesville, FL 32611 USAIndiana Univ, Bloomington, in 47405 USAUniv Miami, Miller Sch Med, Coral Gables, FL 33124 USAHarvard Univ, Childrens Hosp, Sch Med, Cambridge, MA 02138 USAUniversidade Federal de São Paulo, São Paulo, BrazilColumbia Univ, New York, NY 10027 USANYU, Bellevue Hosp, Sch Med, New York, NY USAColumbia Univ, Med Ctr, New York, NY 10027 USAUniversidade Federal de São Paulo, São Paulo, BrazilWeb of Scienc

Parallel algebraic multigrid based on subdomain blocking

The algebraic multigrid (AMG) approach provides a purely algebraic means to tackle the efficient solution of systems of equations posed on large unstructured grids, in 2D and 3D. While sequential AMG has been used for increasingly large problems (with several million unknowns), its application to even larger applications requires a parallel version. Since, in contrast to geometric multigrid, the hierarchy of coarser levels and the related operators develop dynamically during the setup phase of AMG, a direct parallelization is very complicated. Moreover, a "naive" parallelisation would, in general, require unpredictable and highly complex communication patterns which seriously limit the achievable scalability, in particular of the costly setup phase. In this paper, we consider a classical AMG variant which has turned out be highly robust and efficient in solving large systems of equations corresponding to elliptic PDEs, discretized by finite differences or finite volumes. Based on a straightforward partitioning of variables (using one of the available algebraic partitioning tools such as Metis), a parallelisation approach is proposed which minimizes the communication without sacrificing convergence in complex situations. Results will be presented for industrial CFD and oil-reservoir simulation applications on distributed memory machines, including PC-clusters